Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# MONTHS_BETWEEN

Syntax

Description of the illustration months_between.gif

Purpose

`MONTHS_BETWEEN` returns number of months between dates `date1` and `date2`. If `date1` is later than `date2`, then the result is positive. If `date1` is earlier than `date2`, then the result is negative. If `date1` and `date2` are either the same days of the month or both last days of months, then the result is always an integer. Otherwise Oracle Database calculates the fractional portion of the result based on a 31-day month and considers the difference in time components `date1` and `date2`.

Examples

The following example calculates the months between two dates:

    SELECT MONTHS_BETWEEN
       (TO_DATE('02-02-1995','MM-DD-YYYY'),
        TO_DATE('01-01-1995','MM-DD-YYYY') ) "Months"
        FROM DUAL;

        Months
    ----------
    1.03225806